pgwui_sql
2 years agoFix crash when sql execution error has no line number
Karl O. Pinc [Sat, 21 Sep 2024 18:54:47 +0000 (13:54 -0500)]
Fix crash when sql execution error has no line number

2 years agoMake downloading CSV work
Karl O. Pinc [Sat, 21 Sep 2024 03:27:12 +0000 (22:27 -0500)]
Make downloading CSV work

2 years agoAlign column headings left, just like column data
Karl O. Pinc [Sat, 21 Sep 2024 03:27:05 +0000 (22:27 -0500)]
Align column headings left, just like column data

2 years agoUse ? instead of * for help links
Karl O. Pinc [Fri, 20 Sep 2024 20:18:45 +0000 (15:18 -0500)]
Use ? instead of * for help links

2 years agoAdd field for null representation output
Karl O. Pinc [Fri, 20 Sep 2024 18:03:04 +0000 (13:03 -0500)]
Add field for null representation output

2 years agoSimplify template rendering
Karl O. Pinc [Thu, 19 Sep 2024 18:30:58 +0000 (13:30 -0500)]
Simplify template rendering

2 years agoMove logging into a function
Karl O. Pinc [Thu, 19 Sep 2024 18:28:12 +0000 (13:28 -0500)]
Move logging into a function

2 years agoMove "include sql" into the "grid of controls"
Karl O. Pinc [Wed, 18 Sep 2024 19:09:39 +0000 (14:09 -0500)]
Move "include sql" into the "grid of controls"

2 years agoUse a lighter than lightgrey to grey out the sql text when unused
Karl O. Pinc [Wed, 18 Sep 2024 18:56:04 +0000 (13:56 -0500)]
Use a lighter than lightgrey to grey out the sql text when unused

2 years agoAdd user interface elements supporting download
Karl O. Pinc [Wed, 18 Sep 2024 18:22:44 +0000 (13:22 -0500)]
Add user interface elements supporting download

2 years agoHave column headings in SQL results "stick" on the page
Karl O. Pinc [Tue, 17 Sep 2024 22:58:26 +0000 (17:58 -0500)]
Have column headings in SQL results "stick" on the page

2 years agoAdd alert when javascript is turned off
Karl O. Pinc [Tue, 17 Sep 2024 17:06:26 +0000 (12:06 -0500)]
Add alert when javascript is turned off

2 years agoStyle horizontal rules between sql results to be very light
Karl O. Pinc [Mon, 16 Sep 2024 22:26:30 +0000 (17:26 -0500)]
Style horizontal rules between sql results to be very light

2 years agoAdd ability to supply sql via a file
Karl O. Pinc [Mon, 16 Sep 2024 04:17:55 +0000 (23:17 -0500)]
Add ability to supply sql via a file

2 years agoGet rid of example settings error
Karl O. Pinc [Mon, 16 Sep 2024 02:44:46 +0000 (21:44 -0500)]
Get rid of example settings error

2 years agoMove the search_path Reset button closer to the input element
Karl O. Pinc [Mon, 16 Sep 2024 00:43:13 +0000 (19:43 -0500)]
Move the search_path Reset button closer to the input element

2 years agoAdd "Reset" button to reset back to default search_path
Karl O. Pinc [Sun, 15 Sep 2024 23:04:27 +0000 (18:04 -0500)]
Add "Reset" button to reset back to default search_path

2 years agoMove away from XML formatting
Karl O. Pinc [Sun, 15 Sep 2024 22:32:25 +0000 (17:32 -0500)]
Move away from XML formatting

2 years agoProvide a help link for search_path
Karl O. Pinc [Sun, 15 Sep 2024 20:50:48 +0000 (15:50 -0500)]
Provide a help link for search_path

2 years agoPrevent crash of sql editing page when user is not logged in
Karl O. Pinc [Sun, 15 Sep 2024 19:56:57 +0000 (14:56 -0500)]
Prevent crash of sql editing page when user is not logged in

2 years agoApply the requested search_path before executing the supplied SQL
Karl O. Pinc [Sun, 15 Sep 2024 19:42:37 +0000 (14:42 -0500)]
Apply the requested search_path before executing the supplied SQL

2 years agoGive the requested search_path to the html template
Karl O. Pinc [Sun, 15 Sep 2024 18:55:51 +0000 (13:55 -0500)]
Give the requested search_path to the html template

2 years agoRefactor to put search_path code it a separate module
Karl O. Pinc [Sun, 15 Sep 2024 18:34:06 +0000 (13:34 -0500)]
Refactor to put search_path code it a separate module

2 years agoShow search_path in SQL entry window
Karl O. Pinc [Sat, 14 Sep 2024 23:05:47 +0000 (18:05 -0500)]
Show search_path in SQL entry window

2 years agopgwui_server is required for tox testing of template rendering
Karl O. Pinc [Fri, 13 Sep 2024 19:04:49 +0000 (14:04 -0500)]
pgwui_server is required for tox testing of template rendering

2 years agoExplain why we can safely use the SQLHander to process the SQL edit form
Karl O. Pinc [Fri, 13 Sep 2024 18:54:36 +0000 (13:54 -0500)]
Explain why we can safely use the SQLHander to process the SQL edit form

2 years agoRemove blank line
Karl O. Pinc [Fri, 13 Sep 2024 18:52:47 +0000 (13:52 -0500)]
Remove blank line

2 years agoDon't try to automatically open a SQL edit window
Karl O. Pinc [Fri, 13 Sep 2024 18:40:48 +0000 (13:40 -0500)]
Don't try to automatically open a SQL edit window

The problem is that the current sql is not passed to the sql edit
window.  So the new window always opens with no sql.  Changing this
is more bother than it's worth.  At least right now.

2 years agoRequire logging in before use of the sql edit popup
Karl O. Pinc [Fri, 13 Sep 2024 18:24:08 +0000 (13:24 -0500)]
Require logging in before use of the sql edit popup

2 years agoLabel button to match sql edit window title
Karl O. Pinc [Fri, 13 Sep 2024 18:06:20 +0000 (13:06 -0500)]
Label button to match sql edit window title

2 years agoPosition and size, more or less correctly, sql edit window
Karl O. Pinc [Fri, 13 Sep 2024 18:05:47 +0000 (13:05 -0500)]
Position and size, more or less correctly, sql edit window

2 years agoChange window title when showing sql results
Karl O. Pinc [Fri, 13 Sep 2024 17:38:27 +0000 (12:38 -0500)]
Change window title when showing sql results

2 years agoRemove navigation menu from popup sql edit window
Karl O. Pinc [Fri, 13 Sep 2024 16:22:06 +0000 (11:22 -0500)]
Remove navigation menu from popup sql edit window

2 years agoA working control flow from login to sql edit window opening
Karl O. Pinc [Fri, 13 Sep 2024 15:48:48 +0000 (10:48 -0500)]
A working control flow from login to sql edit window opening

2 years agoAdd "login" user interface when not logged in
Karl O. Pinc [Wed, 11 Sep 2024 23:00:02 +0000 (18:00 -0500)]
Add "login" user interface when not logged in

2 years agoTest that templates render, at least somewhat
Karl O. Pinc [Wed, 11 Sep 2024 00:17:51 +0000 (19:17 -0500)]
Test that templates render, at least somewhat

2 years agoBeginnings of a SQL edit window
Karl O. Pinc [Tue, 3 Sep 2024 19:17:53 +0000 (14:17 -0500)]
Beginnings of a SQL edit window

2 years agoImprove code formatting
Karl O. Pinc [Tue, 3 Sep 2024 19:16:33 +0000 (14:16 -0500)]
Improve code formatting

2 years agoBetter menu label
Karl O. Pinc [Tue, 20 Aug 2024 20:25:40 +0000 (15:25 -0500)]
Better menu label

2 years agoBump version number to 0.19.0
Karl O. Pinc [Tue, 20 Aug 2024 19:55:40 +0000 (14:55 -0500)]
Bump version number to 0.19.0

2 years agoStyle SQL text in a monospace font
Karl O. Pinc [Tue, 20 Aug 2024 01:06:07 +0000 (20:06 -0500)]
Style SQL text in a monospace font

2 years agoStyle the PGResult status message
Karl O. Pinc [Tue, 20 Aug 2024 00:56:45 +0000 (19:56 -0500)]
Style the PGResult status message

2 years agoGive the component it's own CSS file
Karl O. Pinc [Tue, 20 Aug 2024 00:56:09 +0000 (19:56 -0500)]
Give the component it's own CSS file

2 years agoReport warning when there are no results
Karl O. Pinc [Mon, 19 Aug 2024 23:57:43 +0000 (18:57 -0500)]
Report warning when there are no results

2 years agoSubclass "runtime" exceptions
Karl O. Pinc [Mon, 19 Aug 2024 23:44:47 +0000 (18:44 -0500)]
Subclass "runtime" exceptions

2 years agoBump version number to 0.18.0
Karl O. Pinc [Mon, 19 Aug 2024 19:48:13 +0000 (14:48 -0500)]
Bump version number to 0.18.0

2 years agoRefactor SQL query result into its own object
Karl O. Pinc [Mon, 19 Aug 2024 17:16:43 +0000 (12:16 -0500)]
Refactor SQL query result into its own object

2 years agoRefactor to abstract formatting of error detail
Karl O. Pinc [Mon, 19 Aug 2024 16:35:49 +0000 (11:35 -0500)]
Refactor to abstract formatting of error detail

2 years agoShow SQL at the top of the results
Karl O. Pinc [Sun, 18 Aug 2024 22:55:53 +0000 (17:55 -0500)]
Show SQL at the top of the results

2 years agoReport on syntax errors without crashing
Karl O. Pinc [Sun, 18 Aug 2024 22:37:15 +0000 (17:37 -0500)]
Report on syntax errors without crashing

2 years agoRefactor to make methods simpler
Karl O. Pinc [Sun, 18 Aug 2024 19:57:03 +0000 (14:57 -0500)]
Refactor to make methods simpler

2 years agoAdd horizontal rules between result of each sql command
Karl O. Pinc [Sun, 18 Aug 2024 19:56:35 +0000 (14:56 -0500)]
Add horizontal rules between result of each sql command

2 years agoRemove unnecessary test
Karl O. Pinc [Sun, 18 Aug 2024 19:54:05 +0000 (14:54 -0500)]
Remove unnecessary test

2 years agoHandle SQL statements that return no result
Karl O. Pinc [Sun, 18 Aug 2024 19:43:04 +0000 (14:43 -0500)]
Handle SQL statements that return no result

2 years agoAdjust for SQL that returns no result
Karl O. Pinc [Sun, 18 Aug 2024 19:08:53 +0000 (14:08 -0500)]
Adjust for SQL that returns no result

2 years agoBring heading type values in line with what the template expects
Karl O. Pinc [Sun, 18 Aug 2024 19:08:28 +0000 (14:08 -0500)]
Bring heading type values in line with what the template expects

2 years agoDocument template variable
Karl O. Pinc [Sun, 18 Aug 2024 19:07:49 +0000 (14:07 -0500)]
Document template variable

2 years agoMove sql execution into upload handler's cleanup() method
Karl O. Pinc [Sun, 18 Aug 2024 18:11:36 +0000 (13:11 -0500)]
Move sql execution into upload handler's cleanup() method

The data line processor is designed to work with lines of data,
and we don't have that.

2 years agoFix log message
Karl O. Pinc [Sun, 18 Aug 2024 18:11:02 +0000 (13:11 -0500)]
Fix log message

2 years agoFix sql textarea generated id
Karl O. Pinc [Sun, 18 Aug 2024 18:10:21 +0000 (13:10 -0500)]
Fix sql textarea generated id

2 years agoKeep sql id from showing up twice in form data
Karl O. Pinc [Sun, 18 Aug 2024 18:09:05 +0000 (13:09 -0500)]
Keep sql id from showing up twice in form data

2 years agoFix SQL textarea name
Karl O. Pinc [Sun, 18 Aug 2024 18:08:08 +0000 (13:08 -0500)]
Fix SQL textarea name

2 years agoFix SQL textarea tabindex
Karl O. Pinc [Sun, 18 Aug 2024 18:07:32 +0000 (13:07 -0500)]
Fix SQL textarea tabindex

2 years agoBuild result rows to be given to the template
Karl O. Pinc [Fri, 16 Aug 2024 22:59:52 +0000 (17:59 -0500)]
Build result rows to be given to the template

2 years agoRemove source code whitespace from rendered form
Karl O. Pinc [Fri, 16 Aug 2024 22:53:48 +0000 (17:53 -0500)]
Remove source code whitespace from rendered form

2 years agoImprove success message
Karl O. Pinc [Fri, 16 Aug 2024 22:52:34 +0000 (17:52 -0500)]
Improve success message

2 years agoMake SQL entry page work
Karl O. Pinc [Fri, 16 Aug 2024 17:25:00 +0000 (12:25 -0500)]
Make SQL entry page work

2 years agoHave a separate module for forms
Karl O. Pinc [Fri, 16 Aug 2024 17:24:21 +0000 (12:24 -0500)]
Have a separate module for forms

2 years agoBump version number to 0.17.0
Karl O. Pinc [Mon, 5 Aug 2024 17:50:15 +0000 (12:50 -0500)]
Bump version number to 0.17.0

2 years agoBump version number to 0.16.0
Karl O. Pinc [Mon, 5 Aug 2024 17:04:51 +0000 (12:04 -0500)]
Bump version number to 0.16.0

2 years agoProperly initialize the upload handler
Karl O. Pinc [Sun, 4 Aug 2024 20:48:29 +0000 (15:48 -0500)]
Properly initialize the upload handler

2 years agoDependencies are dynamic because they contain version numbers
Karl O. Pinc [Sun, 4 Aug 2024 17:40:16 +0000 (12:40 -0500)]
Dependencies are dynamic because they contain version numbers

2 years agoPut page heading in the base template
Karl O. Pinc [Sat, 3 Aug 2024 21:23:51 +0000 (16:23 -0500)]
Put page heading in the base template

2 years agoUse table row abstractions
Karl O. Pinc [Sat, 3 Aug 2024 21:21:53 +0000 (16:21 -0500)]
Use table row abstractions

2 years agoAdjust for pgwui_common template structure changes
Karl O. Pinc [Wed, 31 Jul 2024 17:46:56 +0000 (12:46 -0500)]
Adjust for pgwui_common template structure changes

2 years agoMove core utility functions into a separate module
Karl O. Pinc [Tue, 16 Jul 2024 22:11:11 +0000 (17:11 -0500)]
Move core utility functions into a separate module

2 years agoBetter response variable name db_changed -> report_success
Karl O. Pinc [Tue, 16 Jul 2024 12:48:16 +0000 (07:48 -0500)]
Better response variable name db_changed -> report_success

2 years agoBump version number to 0.15.0
Karl O. Pinc [Sun, 23 Jun 2024 02:07:00 +0000 (21:07 -0500)]
Bump version number to 0.15.0

2 years agoA little bit of work away from the basic template
Karl O. Pinc [Sun, 23 Jun 2024 02:06:04 +0000 (21:06 -0500)]
A little bit of work away from the basic template

2 years agoUse immediate assignments
Karl O. Pinc [Sat, 22 Jun 2024 03:21:05 +0000 (22:21 -0500)]
Use immediate assignments

2 years agoFix conditional yamllint execution
Karl O. Pinc [Fri, 21 Jun 2024 23:10:58 +0000 (18:10 -0500)]
Fix conditional yamllint execution

2 years agoAvoid rebuilding packages when running check targets
Karl O. Pinc [Fri, 21 Jun 2024 23:10:01 +0000 (18:10 -0500)]
Avoid rebuilding packages when running check targets

2 years agoRun yamllint when checking
Karl O. Pinc [Fri, 21 Jun 2024 19:28:15 +0000 (14:28 -0500)]
Run yamllint when checking

2 years agoInitial commit
Karl O. Pinc [Wed, 12 Jun 2024 18:23:34 +0000 (13:23 -0500)]
Initial commit